package com.chhh.cranelease.mapper;

import com.chhh.cranelease.entity.CarInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface CarInfoDao {
 /*   @Select("select * from carinfo")
    List<CarInfo> selectAll();*/
    @Select("select * from carinfo where c_model=1")
    List<CarInfo> selectAll1();
    @Select("select * from carinfo where c_model=2")
    List<CarInfo> selectAll2();
    @Select("select * from carinfo where c_model=3")
    List<CarInfo> selectAll3();
    @Select("select * from carinfo where c_model=4")
    List<CarInfo> selectAll4();
    @Select("select * from carinfo where c_model=5")
    List<CarInfo> selectAll5();
    @Select("select * from carinfo where c_model=6")
    List<CarInfo> selectAll6();
    @Select("select * from carinfo where c_model=7")
    List<CarInfo> selectAll7();
    @Select("select * from carinfo where c_model=8")
    List<CarInfo> selectAll8();

}
